1 <?php
2 session_start(); // Use session variable on this page. This function must put on the top of page.
3 if(!isset($_SESSION['username']) || $_SESSION['usertype'] !='admin'){ // if session variable "username" does not exist.
4 header("location:index.php?msg=Please%20login%20to%20access%20admin%20area%20!"); // Re-direct to index.php
5 }
6 else
7 {
8 include_once "db.php";
9 error_reporting (E_ALL ^ E_NOTICE);
10
11 ?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
12 "http://www.w3.org/TR/html4/loose.dtd">
13 <html>
14 <head>
15 <title>Welcome to Stock Management System !</title>
16 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
17 <link rel="stylesheet" href="css/validationEngine.jquery.css" type="text/css" media="screen" title="no title" charset="utf-8" />
18 <link rel="stylesheet" href="css/template.css" type="text/css" media="screen" title="no title" charset="utf-8" />
19 <script src="js/jquery.min.js" type="text/javascript"></script>
20
21 <script type='text/javascript' src='lib/jquery.bgiframe.min.js'></script>
22 <script type='text/javascript' src='lib/jquery.ajaxQueue.js'></script>
23 <script type='text/javascript' src='lib/thickbox-compressed.js'></script>
24 <script type='text/javascript' src='jquery.autocomplete.js'></script>
25 <script type='text/javascript' src='localdata.js'></script>
26
27 <link rel="stylesheet" type="text/css" href="jquery.autocomplete.css" />
28 <link rel="stylesheet" type="text/css" href="lib/thickbox.css" />
29
30 <script type="text/javascript">
31 $().ready(function() {
32
33 function log(event, data, formatted) {
34 $("<li>").html( !data ? "No match!" : "Selected: " + formatted).appendTo("#result");
35 }
36
37 function formatItem(row) {
38 return row[0] + " (<strong>id: " + row[1] + "</strong>)";
39 }
40 function formatResult(row) {
41 return row[0].replace(/(<.+?>)/gi, '');
42 }
43
44
45
46 $("#singleBirdRemote").autocomplete("category.php", {
47 width: 160,
48 autoFill: true,
49 selectFirst: false
50 });
51 $("#supplier").autocomplete("supplier1.php", {
52 width: 160,
53 autoFill: true,
54 selectFirst: false
55 });
56
57
58 $("#clear").click(function() {
59 $(":input").unautocomplete();
60 });
61 });
62
63
64 </script>
65
66 <script src="js/jquery.validationEngine-en.js" type="text/javascript"></script>
67 <script src="js/jquery.validationEngine.js" type="text/javascript"></script>
68 <script src="js/jquery.hotkeys-0.7.9.js"></script>
69 <!-- AJAX SUCCESS TEST FONCTION
70 <script>function callSuccessFunction(){alert("success executed")}
71 function callFailFunction(){alert("fail executed")}
72 </script>
73 -->
74
75 <script>
76
77
78
79
80
81 $(document).ready(function() {
82 // SUCCESS AJAX CALL, replace "success: false," by: success : function() { callSuccessFunction() },
83 $("#name").focus();
84 $("#form1").validationEngine(),
85
86 jQuery(document).bind('keydown', 'Ctrl+s',function() {
87 $('#form1').submit();
88 return false;
89 });
90
91 jQuery(document).bind('keydown', 'Ctrl+r',function() {
92 $('#form1').reset();
93 return false;
94 });
95 jQuery(document).bind('keydown', 'Ctrl+a',function() {
96 window.location = "addstock.php";
97 return false;
98 });
99 jQuery(document).bind('keydown', 'Ctrl+0',function() {
100 window.location = "admin.php";
101 return false;
102 });
103 jQuery(document).bind('keydown', 'Ctrl+1',function() {
104 window.location = "add_purchase.php";
105 return false;
106 });
107 jQuery(document).bind('keydown', 'Ctrl+2',function() {
108 window.location = "add_stock_sales.php";
109 return false;
110 });
111 jQuery(document).bind('keydown', 'Ctrl+3',function() {
112 window.location = "add_stock_details.php";
113 return false;
114 });
115 jQuery(document).bind('keydown', 'Ctrl+4',function() {
116 window.location = "add_category.php";
117 return false;
118 });
119 jQuery(document).bind('keydown', 'Ctrl+5',function() {
120 window.location = "add_supplier_details.php";
121 return false;
122 });
123 jQuery(document).bind('keydown', 'Ctrl+6',function() {
124 window.location = "add_customer_details.php";
125 return false;
126 });
127 jQuery(document).bind('keydown', 'Ctrl+7',function() {
128 window.location = "view_stock_entries.php";
129 return false;
130 });
131 jQuery(document).bind('keydown', 'Ctrl+8',function() {
132 window.location = "view_stock_sales.php";
133 return false;
134 });
135 jQuery(document).bind('keydown', 'Ctrl+9',function() {
136 window.location = "view_stock_details.php";
137 return false;
138 });
139 //$.validationEngine.loadValidation("#date")
140 //alert($("#formID").validationEngine({returnIsValid:true}))
141 //$.validationEngine.buildPrompt("#date","This is an example","error") // Exterior prompt build example // input prompt close example
142 //$.validationEngine.closePrompt(".formError",true) // CLOSE ALL OPEN PROMPTS
143 });
144 </script>
145 <style type="text/css">
146 <!--
147 body {
148 margin-left: 0px;
149 margin-top: 0px;
150 margin-right: 0px;
151 margin-bottom: 0px;
152 background-color: #FFFFFF;
153 }
154
155 *{
156 padding: 0px;
157 margin: 0px;
158 }
159 #vertmenu {
160 font-family: Verdana, Arial, Helvetica, sans-serif;
161 font-size: 100%;
162 width: 160px;
163 padding: 0px;
164 margin: 0px;
165 }
166
167 #vertmenu h1 {
168 display: block;
169 background-color:#FF9900;
170 font-size: 90%;
171 padding: 3px 0 5px 3px;
172 border: 1px solid #000000;
173 color: #333333;
174 margin: 0px;
175 width:159px;
176 }
177
178 #vertmenu ul {
179 list-style: none;
180 margin: 0px;
181 padding: 0px;
182 border: none;
183 }
184 #vertmenu ul li {
185 margin: 0px;
186 padding: 0px;
187 }
188 #vertmenu ul li a {
189 font-size: 80%;
190 display: block;
191 border-bottom: 1px dashed #C39C4E;
192 padding: 5px 0px 2px 4px;
193 text-decoration: none;
194 color: #666666;
195 width:160px;
196 }
197
198 #vertmenu ul li a:hover, #vertmenu ul li a:focus {
199 color: #000000;
200 background-color: #eeeeee;
201 }
202 .style1 {color: #000000}
203
204 -->
205 </style>
206 </head>
207
208 <body>
209 <table width="100%" border="0" cellspacing="0" cellpadding="0">
210 <tr>
211 <td align="center" valign="top"><table width="960" border="0" cellspacing="0" cellpadding="0">
212 <tr>
213 <td><table width="960" border="0" cellpadding="0" cellspacing="0" bgcolor="#ECECEC">
214 <tr>
215 <td height="90" align="left" valign="top"><img src="images/topbanner.jpg" width="960" height="82"></td>
216 </tr>
217 <tr>
218 <td height="800" align="left" valign="top"><table width="960" border="0" cellpadding="0" cellspacing="0" bgcolor="#ECECEC">
219 <tr>
220 <td width="130" align="left" valign="top">
221
222 <br>
223
224 <strong>Welcome <font color="#3399FF"><?php echo $_SESSION['username']; ?> !</font></strong><br> <br>
225 <table width="100%" border="0" cellspacing="0" cellpadding="0">
226 <tr>
227 <td align="center"><a href="admin.php"><img src="images/home.png" width="130" height="99" border="0"></a></td>
228 </tr>
229 <tr>
230 <td align="center"> </td>
231 </tr>
232 <tr>
233 <td align="center"><a href="add_purchase.php"><img src="images/purchase.png" width="130" height="124" border="0"></a></td>
234 </tr>
235 <tr>
236 <td align="center"> </td>
237 </tr>
238 <tr>
239 <td align="center"><a href="add_stock_sales.php"><img src="images/sales.png" width="146" height="111" border="0"></a></td>
240 </tr>
241 <tr>
242 <td align="center"> </td>
243 </tr>
244 <tr>
245 <td align="center"><a href="report.php"><img src="images/reports.png" width="131" height="142" border="0"></a></td>
246 </tr>
247 <tr>
248 <td align="center"> </td>
249 </tr>
250 <tr>
251 <td align="center"> </td>
252 </tr>
253 <tr>
254 <td align="center"> </td>
255 </tr>
256 </table>
257
258
259
260
261
262 </td> <td height="500" align="center" valign="top">
263 <table width="100%" border="0" cellspacing="0" cellpadding="0">
264 <tr>
265 <td><a href="add_stock_details.php"><img src="images/addstockdetails.png" width="67" height="62" border="0"></a></td>
266 <td><a href="add_supplier_details.php"><img src="images/supplier.png" width="67" height="54" border="0"></a></td>
267 <td><a href="add_customer_details.php"><img src="images/customer.png" width="67" height="54" border="0"></a></td>
268 <td><a href="add_category.php"><img src="images/categories.png" width="67" height="54" border="0"></a></td>
269 <td><a href="view_stock_sales.php"><img src="images/vsales.png" width="67" height="54" border="0"></a></td>
270 <td><a href="view_stock_entries.php"><img src="images/vpurchase.png" width="67" height="54" border="0"></a></td>
271 <td><a href="view_stock_details.php"><img src="images/stockdetails.png" width="67" height="54" border="0"></a></td>
272 <td><a href="view_stock_availability.php"><img src="images/savail.png" width="67" height="54" border="0"></a></td>
273 <td align="left" valign="top"><a href="view_customer_details.php"><img src="images/customers.png" width="94" height="22" border="0"></a><br> <a href="view_supplier_details.php"><img src="images/suppliers.png" width="94" height="22" border="0"></a><br>
274 <a href="view_payments.php"><img src="images/payments.png" width="94" height="22" border="0"></a></td>
275 <td align="left" valign="top"><a href="view_stock_sales_payments.php"><img src="images/outstanding.png" width="94" height="22" border="0"></a><br> <a href="view_stock_entries_payments.php"><img src="images/pendings.png" width="94" height="22" border="0"></a><br>
276 <a href="logout.php"><img src="images/logout.png" width="94" height="22" border="0"></a></td>
277 </tr>
278 </table>
279 <?php
280 if(isset($_POST['name']))
281
282 {
283 $id=$_GET['id'];
284 $sid=mysql_real_escape_string($_POST['id']);
285 $name=mysql_real_escape_string($_POST['name']);
286 $category=mysql_real_escape_string($_POST['category']);
287 $buyingrate=mysql_real_escape_string($_POST['buyingrate']);
288 $sellingrate=mysql_real_escape_string($_POST['sellingrate']);
289 $suplier=mysql_real_escape_string($_POST['suplier']);
290 $uom=mysql_real_escape_string($_POST['uom']);
291 $expiry=mysql_real_escape_string($_POST['expiry']);
292
293 $db->execute("UPDATE stock_details SET stock_id='$sid',stock_name='$name',supplier_id='$suplier',company_price=$buyingrate,selling_price=$sellingrate,category='$category',expire_date='$expiry' WHERE id=$id");
294
295
296 echo "<br><font color=green size=+1 > [$name] Stock Details Updated !</font>" ;
297
298
299
300
301
302
303 }
304
305 if(isset($_GET['id']))
306 {
307
308 $id=$_GET['id'];
309
310 ?>
311
312 <br>
313 <br>
314
315
316 <form name="form1" method="post" id="form1" action="">
317
318 <p align="center"><strong>Add New Stock Details </strong> - Add New ( Control +A)</p>
319 <table width="300" border="0" cellspacing="0" cellpadding="0">
320 <tr>
321 <td width="150"> </td>
322 <td width="150"> </td>
323 </tr>
324 <tr>
325 <td width="150"> </td>
326 <td width="150"> </td>
327 </tr>
328 <tr>
329 <td width="150">ID</td>
330 <td width="150"><input name="id" type="text" id="id" readonly="" value="<?php echo $db->queryUniqueValue("SELECT stock_id FROM stock_details WHERE id=$id"); ?>"></td>
331 </tr>
332 <tr>
333 <td width="150"> </td>
334 <td width="150"> </td>
335 </tr>
336 <tr>
337 <td width="150">Name</td>
338 <td width="150"><input name="name" type="text" id="name" class="validate[required,length[0,100]] text-input" value="<?php echo $db->queryUniqueValue("SELECT stock_name FROM stock_details WHERE id=$id"); ?>"></td>
339 </tr>
340 <tr>
341 <td width="150"> </td>
342 <td width="150"> </td>
343 </tr>
344 <tr>
345 <td width="150">Category</td>
346 <td width="150"><input name="category" type="text" id="singleBirdRemote" value="<?php echo $db->queryUniqueValue("SELECT category FROM stock_details WHERE id=$id"); ?>"></td>
347 </tr>
348 <tr>
349 <td> </td>
350 <td> </td>
351 </tr>
352 <tr>
353 <td>Buying Rate</td>
354 <td><input name="buyingrate" type="text" id="buyingrate" class="validate[required,custom[onlyNumber],lengthCheck[6]] text-input" value="<?php echo $db->queryUniqueValue("SELECT company_price FROM stock_details WHERE id=$id"); ?>"></td>
355 </tr>
356 <tr>
357 <td> </td>
358 <td> </td>
359 </tr>
360 <tr>
361 <td>Selling Rate </td>
362 <td><input name="sellingrate" type="text" id="sellingrate" class="validate[required,custom[onlyNumber],lengthCheck[6]] text-input" value="<?php echo $db->queryUniqueValue("SELECT selling_price FROM stock_details WHERE id=$id"); ?>"></td>
363 </tr>
364 <tr>
365 <td> </td>
366 <td> </td>
367 </tr>
368 <tr>
369 <td>Suplier Name</td>
370 <td><input name="suplier" type="text" id="supplier" class="validate[optional,length[0,100]] text-input" value="<?php echo $db->queryUniqueValue("SELECT supplier_id FROM stock_details WHERE id=$id"); ?>"></td>
371 </tr>
372 <tr>
373 <td> </td>
374 <td> </td>
375 </tr>
376
377 <td> </td>
378 <td> </td>
379 </tr>
380 <tr>
381 <td>Expiry Date </td>
382 <td><input name="expiry" type="text" id="expiry" class="validate[optional,length[0,100]] text-input" value="<?php echo $db->queryUniqueValue("SELECT expire_date FROM stock_details WHERE id=$id"); ?>" ></td>
383 </tr>
384 <tr>
385 <td> </td>
386 <td> </td>
387 </tr>
388 <tr>
389 <td align="right"><input type="button" name="cancel" value="Cancel" onClick="javascript:location.href='view_stock_details.php';" > </td>
390 <td>
391 <input type="submit" name="Submit" value="Update"></td>
392 </tr>
393 <tr>
394 <td align="center"> </td>
395 <td align="left"> ( Control + S ) </td>
396 </tr>
397 </table>
398 </form>
399 <?php
400 }
401 else
402 echo "Error in processing the stock details updation";
403 ?>
404 </td>
405 </tr>
406 </table>
407
408 </td>
409 </tr>
410 <tr>
411 <td height="30" align="center" bgcolor="#72C9F4"><span class="style1"><a href="http://www.pluskb.com">Developed by PlusKB Innovations</a></span></td>
412 </tr>
413 </table></td>
414 </tr>
415 </table></td>
416 </tr>
417 </table>
418
419 </body>
420 </html>
421 <?php
422 }
423 ?>